FO_TestsXContainers

This table allows the administrator to indicate container processing details regarding a test order. Each record is defined by a three item value of test code, container code and sub-container code.

The container and sub-container codes will be the same value unless the test code requires multiple containers per collection. In that case the container code must be a code that represents the group of individual sub-container codes and it should be valued the same for each sub-container code. In this case there must be multiple records defined, one for each sub-container code.

This table can also be used to indicate multiple options for containers for a test. For example if Glucose may be performed in either a red top or a green top tube then two records should be created, one for each container code for this test. The default container in this case will be the container code in the FO_TESTS table. The system will indicate container collection options to the User in the order screen by clicking in the container code field then using the drop down arrow.

 

Field Type Notes

TestsXContainer_ID

int

ID field, a counter. Unique

TestCode

varchar(50)

Enter a valid test code.

ContainerCode

varchar(50)

Container code for this test code.

The system will search this table by test code and container code at the time of a test order.

The container code used for searching is the container code on the order screen.

SubContainerCode

varchar(50)

Use the same code as ContainerCode.

Must be the same as ContainerCode if the test does not have more than one sub-container for the container code.

ContainerType

varchar(50)

Name for the sub-container code.

SpecimenTypeCode

varchar(50)

Default specimen code for this test/container pair.

Enter a valid specimen code.

LabDept

varchar(50)

Lab department.

Enter a valid lab department code.

SpotCode

varchar(50)

Spot code which is printed on labels.

Enter a valid spot code.

Indicates the actual testing bench for this test/container pair.

Destination

varchar(500)

Enter convention designed codes separated by dashes.

Specifies destination related information for this test/container pair.

It can be printed on labels.

IE: SPIN-PL-Trans

This example specifies to spin the tube then protect from light then transport.

Also can begin with #MC# to indicate that the microbiology label format should replace the default label format for this testcode/container pair.

LISMethod

varchar(50)

Method code for this test.

Informational

LISWorksheet

varchar(50)

Worksheet name for this test.

Informational

LabelGroup

varchar(50)

Critical component in container assembly.

The system will use this value to include or exclude tests with the same container to a single CID (container id).

The system will check the performing lab first, then the container code, then the total volume of all the tests and, finally, the value of this field.

This field value can be used to force separation where the first three components are the same.

NOLABEL is specifically recognized as no label needs to print.

AliquotLabelContents

varchar(500)

Enter a value based on aliquot rule set presented in the label module section.

Causes the system to print an aliquot label according to rules.

Storage

varchar(50)

Enter a valid storage code as defined in the FO_Types_Storage table.

CollectVolume

numeric(18, 2)

Minimum collection volume for this test/container pair.

Enter a real number with two decimal places such as 23.45

ContainerGroup

varchar(500)

Informational

AliquoteContainerCodes

varchar(255)

Defines the list of aliquot container codes that qualify for this test/container pair.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid container codes, as defined in the FO_Types_Container table, separated by pipes.

LabelQuantity

int

Number of labels that should print for the test/container pair.

Enter a valid integer.

DedicateContainer

varchar(50)

Determines if this test/container pair should combine with other tests of a like container.

Enter Y or N

Y = yes, combine with other tests

N = no, do not combine with other tests.

LabelFormatID

varchar(50)

The format name identifying what label format will be printed for the container label for this test/container pair.

Must correspond to an existing format in the text file (format.txt).

If populated, this format will override the default format defined in the FO_LabelConfig.

This ID will get recorded in FO_Acc_Tubes.

This is used for container labels only.

**CAUTION** is required in assigning test/container pair specific labels formats.

Care must be taken so no container is created that would have multiple conflicting specific label formats.